CREATE TABLE [dbo].[JOL_FacultyActivities]
(
[JOL_FacultyActivities_ID] [int] NOT NULL IDENTITY(1, 1),
[JOL_FacultyActivities_Faculty] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_FacultyActivities_FacultyID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_FacultyActivities_Type] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_FacultyActivities_Title] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_FacultyActivities_Site] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_FacultyActivities_StartTime] [datetime] NULL,
[JOL_FacultyActivities_EndTime] [datetime] NULL,
[JOL_FacultyActivities_Host] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_FacultyActivities_Organizers] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_FacultyActivities_Participants] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_FacultyActivities_Introduction] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[JOL_FacultyActivities_Comment] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[JOL_FacultyActivities_WorkRecord] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[JOL_FacultyActivities_AddTime] [datetime] NULL,
[JOL_FacultyActivities_AddUser] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_FacultyActivities_UpdateTime] [datetime] NULL,
[JOL_FacultyActivities_UpdateUser] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_FacultyActivities_VerifyTime] [datetime] NULL,
[JOL_FacultyActivities_VerifyUser] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_FacultyActivities_VerifyState] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_FacultyActivities_VisitCounts] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[JOL_FacultyActivities] ADD CONSTRAINT [PK_JOL_FacultyActivities] PRIMARY KEY CLUSTERED  ([JOL_FacultyActivities_ID]) ON [PRIMARY]
GO
